Problem Note 38325: "ERROR: Variable DIR_x has been defined as both character and numeric" when adding totals to a list table that does not contain a measure
 |  |  |  |
In SAS® Web Report Studio, if you attempt to add totals to a list table, you might see the following error if the table does not contain any measures.
Missing report element An error occurred in processing the report element. Please refresh the page to try again. Contact your administrator if this problem persists.
The error details will include the following relevant error:
ERROR: Variable DIR_x has been defined as both character and numeric. at com.sas.iquery.execution.instructions.SASSubmitHandler.execute(SASSubmitHandler.java:207) .....
This problem occurs if the first data item in the table is a numeric category. For example, a social security number might be a numeric category.
As a workaround, rearrange the columns so that the first column is a character category, or add a measure to the table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Query and Reporting ==> Interactive Querying |
| Date Modified: | 2010-01-07 12:01:52 |
| Date Created: | 2010-01-07 11:47:26 |